11. Exercise: Pivot Tables

Exercise: Pivot Tables

In this exercise, you will follow the same steps as in the demo to create a pivot table from data and answer questions. The only difference is that you will use the now familiar ALbb_salaries_2003.csv data set to do so.

Task Description:

The following list has a series of steps for this exercise. As you complete each step, check it off the list. The quizzes in the task list can be found below.

Task List:

Task Feedback:

Congratulations!

Player Counts

QUESTION:

How many Outfielders play for the New York Yankees?

SOLUTION:

NOTE: The solutions are expressed in RegEx pattern. Udacity uses these patterns to check the given answer

Salary Sums

QUESTION:

How much did the Boston Red Sox team spend on Shortstop salaries in 2003?

SOLUTION:

NOTE: The solutions are expressed in RegEx pattern. Udacity uses these patterns to check the given answer